package com.fjnldx.mes.mapper.productionPlanManagement;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.fjnldx.mes.domain.domainReq.QueryDevSnAndStatusReq;
import com.fjnldx.mes.domain.pojo.AddDailyPlanOfPzCom;
import com.fjnldx.mes.domain.pojo.MesNewscjhPojo;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Component;

import java.time.LocalDate;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

@Mapper
@Component
public interface ProductionPlanManagementMapper extends BaseMapper<MesNewscjhPojo> {
    // 查询细纱机台可用状态
    List<Map<String, Object>> queryDevSnAndStatusXs(String devSnAreaQf,LocalDate time);
    List<Map<String, Object>> queryDevSnAndStatusLt(String cj, String pz, LocalDate time);
    List<Map<String, Object>> queryDevSnAndStatusQf(LocalDate time,String gongxu,String cj, String pz,ArrayList<String> dicBhList);
    List<Map<String, Object>> queryDevSnAndStatusXsWithoutId(LocalDate time);
    List<Map<String, Object>> queryDevSnAndStatusQfWithoutId(LocalDate time,String gongxu, ArrayList<String> dicBhList);
    List<Map<String, Object>> queryDevSnAndStatusLtWithoutId(LocalDate time);
    // 查询粗纱机台可用状态
    List<Map<String, Object>> queryDevSnAndStatusCs(String devSnAreaQf,LocalDate time);
    List<Map<String, Object>> queryDevSnAndStatusCsWithoutId(LocalDate time);

    List<AddDailyPlanOfPzCom> computeAddDailyPlanOfPzParam(Map<String, Object> queryMap);

    List<Map<String, Object>> queryDailyPlanXsInfo(QueryDevSnAndStatusReq queryDailyPlanXsReq);
    List<Map<String, Object>> queryDailyPlanQfInfo(QueryDevSnAndStatusReq queryDailyPlanXsReq);
    List<Map<String, Object>> queryDailyPlanLtInfo(QueryDevSnAndStatusReq queryDailyPlanXsReq);

    List<Map<String, Object>> queryDailyPlanXsQcSum(QueryDevSnAndStatusReq queryDailyPlanXsReq);
    List<Map<String, Object>> queryDailyPlanQfQcSum(QueryDevSnAndStatusReq queryDailyPlanXsReq);
    List<Map<String, Object>> queryDailyPlanLtQcSum(QueryDevSnAndStatusReq queryDailyPlanXsReq);

    List<Map<String, Object>> queryDailyPlanXsCjSum(QueryDevSnAndStatusReq queryDailyPlanXsReq);
    List<Map<String, Object>> queryDailyPlanQfCjSum(QueryDevSnAndStatusReq queryDailyPlanXsReq);
    List<Map<String, Object>> queryDailyPlanLtCjSum(QueryDevSnAndStatusReq queryDailyPlanXsReq);

    String queryDailyPlanXsOfPlanner(QueryDevSnAndStatusReq queryDailyPlanXsReq);

    List<String> selectCsDevSn();

}
